<?php 
$this->E_D("DROP TABLE IF EXISTS `db_cms_contract`;");
$this->E_C("CREATE TABLE `db_cms_contract` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `thumb` varchar(255) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `titleurl` varchar(255) NOT NULL DEFAULT '',
  `newstime` int(11) unsigned NOT NULL DEFAULT '0',
  `pagetitle` varchar(255) NOT NULL DEFAULT '',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `pubid` bigint(15) unsigned NOT NULL DEFAULT '0',
  `sort` int(11) unsigned NOT NULL DEFAULT '0',
  `userid` int(11) unsigned NOT NULL DEFAULT '0',
  `username` char(20) NOT NULL DEFAULT '',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `editortime` int(10) unsigned NOT NULL DEFAULT '0',
  `is_good` int(11) NOT NULL DEFAULT '0' COMMENT '推荐',
  `is_top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶',
  `views` int(11) NOT NULL DEFAULT '0' COMMENT '点击总数',
  `goods` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
  `favs` int(11) NOT NULL DEFAULT '0' COMMENT '收藏数',
  `comments` int(11) NOT NULL DEFAULT '0' COMMENT '评论数',
  `viewtemp` int(11) NOT NULL DEFAULT '0' COMMENT '单独内容模板',
  `tel` varchar(255) DEFAULT '',
  `fox` varchar(255) DEFAULT '',
  `address` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`),
  KEY `sort` (`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='table'");
$this->E_D("replace into `db_cms_contract` values('1','100','58','总部','','','','1636364397','','','','16363564451359','0','2','kenuo','1636364399','1636364399','0','0','0','0','0','0','0','+86-21-50188680','+86-513-81265000','江苏省海门市海门港新区发展大道1189号');");
$this->E_D("replace into `db_cms_contract` values('2','100','58','生产基地','','','','1636364390','','','','16363564801294','0','2','kenuo','1636364392','1636364392','0','0','0','0','0','0','0','+86-513-82777000','+86-513-81265000','江苏省海门市海门港新区发展大道1189号');");

 ?>